package com.example.springboot.mapper;


import com.example.springboot.entity.ProdProgress;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ProdProgressMapper {

    //选择所有delay产品
    @Select("select * from progress order by delayDay desc")
    List<ProdProgress> selectAll();


    //通过负责人查询


    //通过产品任务ID删除任务
    @Delete("delete from `progress` where id=#{id}")
    void delProByID(Integer id);

}
